omc0127 - immovable property omc0127 real estate collateral location postal code mandatory

Card of business rule immovable property omc0127 real estate collateral location postal code mandatory

Name

immovable property omc0127 real estate collateral location postal code mandatory

Code

omc0127

Comment

At least one of the three attributes that indicate the real estate location is reported. Preferably, 'real estate collateral location country' and 'real estate collateral postal code' are reported.

In order of preference:
• If a postal code is in use in the relevant country, the real estate collateral location is identified by the two-digit ISO code of the country and the postal code of the region where the real estate is located;
• If no postal code is in use in the relevant country, but the NUTS3 codes are in use (i.e. it is located in a Member State), the real estate collateral location is identified by (the country and) the NUTS3 code;
• If neither postal codes nor NUTS3 codes are in use in the relevant country, the real estate collateral location is identified by a two-digit ISO code of the country.

ECB Validation identifier: CT0570

Rule Type

Constraint


Server expression of the business rule immovable property omc0127 real estate collateral location postal code mandatory

(if ('immovable property'.'real estate collateral location postal code' is null and
'immovable property'.'reporting agent identifier' = 'collateral located in a reporting member state'.'reporting agent identifier' and
'immovable property'.'protection identifier' = 'collateral located in a reporting member state'.'protection identifier' and
'immovable property'.'reporting reference date' = 'collateral located in a reporting member state'.'reporting reference date')
then
('collateral located in a reporting member state'.'real estate collateral location region' is not null))


List of DNB-specific attributes of the business rule immovable property omc0127 real estate collateral location postal code mandatory

Name

Value

business rule classification

other model constraint

business rule scope

Checked within the data delivery

business rule status

active business rule

number of dependencies

1

severity

blocking


List of attached objects of the business rule immovable property omc0127 real estate collateral location postal code mandatory

Short Description

Entity Attribute 'immovable property.real estate collateral location postal code'